package com.ybybh.gamecenter.mapper;


import com.ybybh.gamecenter.entity.Game;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface GameMapper {

    @Select("select * from games where isavailable='1'")
    public List<Game> selectAll();
    //从数据库中查询得到首页想要展现的最新上架游戏列表
    @Select("select * from games where isavailable='1' order by createtime desc limit 0,12")
    public List<Game> selectNewIndex();

}
